set hive.exec.dynamic.partition=true;            --  动态分区
set hive.exec.dynamic.partition.mode=nonstrict;
set hive.exec.max.dynamic.partitions=90;         --  每天生成 60 个分区
set hive.exec.max.dynamic.partitions.pernode=90; --  每天生成 60 个分区

insert overwrite table jms_dim.dim_sys_manage_region
select
   id
   ,name
   ,code
   ,proxy_network_id
   ,is_delete
   ,create_by
   ,update_by
   ,create_by_name
   ,update_by_name
   ,create_time
   ,update_time
from
    jms_ods.sys_manage_region
where
    dt = '{{ execution_date | cst_ds }}'